--Default Values

SET QUOTED_IDENTIFIER ON;
GO
SET ANSI_NULLS ON;
GO

-- Insert Amaps
-- Id = 1
INSERT INTO AmapSet(RNA, Name, Address1, PostalCode, City, PhoneNumber, Latitude, Longitude, Email, SQLServerLoginName, ForeignAmapId)
	VALUES ('W123456789', 'Les Marrons', '52 rue de Metz', '54000', 'Nancy', '0645743617', 48.701866, 6.171931, 'florent.henry@gmail.com', 'Pharaoh12\Florent', 0)
-- Id = 2
INSERT INTO AmapSet(RNA, Name, Address1, PostalCode, City, PhoneNumber, Latitude, Longitude, Email, SQLServerLoginName, ForeignAmapId)
	VALUES ('W987654321', 'Troll Amap', '70 rue Isabey', '54000', 'Nancy', '0645732443', 48.698318, 6.169102, 'neuhart.julien@gmail.com', 'Julien', 2)